CREATE TABLE `tbladmin` (`intid` int(11) NOT NULL auto_increment,`varadminfname` varchar(250) NOT NULL,`varadminname` varchar(100) NOT NULL,`varpassword` varchar(100) NOT NULL,`intstatus` int(11) NOT NULL,`varemail` varchar(250) NOT NULL,`ttLastLogginDatetime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

CREATE TABLE `tblbanners` (  `intbannerid` int(20) NOT NULL auto_increment,  `varbannertitle` varchar(250) NOT NULL,  `varbannerurl` varchar(250) NOT NULL,  `varbannerimage` varchar(250) NOT NULL,  `intbannercategory` int(20) NOT NULL,  `dtexpiredate` datetime NOT NULL,  `dtadded` datetime NOT NULL,  `dtstatuschange` datetime NOT NULL,  `intstatus` int(20) NOT NULL,  PRIMARY KEY  (`intbannerid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblcart` (  `intcartid` int(20) NOT NULL auto_increment,  `intcustomerid` int(20) NOT NULL,  `varsessionid` varchar(200) NOT NULL,  `intprodid` int(20) NOT NULL,  `intquantitiy` int(20) NOT NULL,  `dtadded` datetime NOT NULL,  PRIMARY KEY  (`intcartid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblcontact` (  `intid` int(20) NOT NULL auto_increment,  `varname` varchar(200) NOT NULL,  `varemail` varchar(200) NOT NULL,  `varphone` varchar(200) default '0',  `txtmess` text NOT NULL,  `intsentby` int(11) default NULL,  `varreply` varchar(4) default NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblcountry` (  `intid` int(11) NOT NULL auto_increment,  `varcountryname` varchar(100) NOT NULL,  `char_iso-code2` char(2) NOT NULL,  `char_iso-code3` char(3) NOT NULL,  `imgcountryicon` varchar(250) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

CREATE TABLE `tblcurrencies` (  `intid` int(11) NOT NULL auto_increment,  `vartitle` varchar(250) NOT NULL,  `varcurrcode` varchar(5) NOT NULL,  `varsymbolleft` varchar(12) NOT NULL,  `varsymbolright` varchar(12) NOT NULL,  `decvalues` decimal(10,2) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

CREATE TABLE `tblcusaddress` (  `intid` int(11) NOT NULL auto_increment,  `intcusid` int(11) NOT NULL,  `varaddrs1` varchar(250) NOT NULL,  `varaddrs2` varchar(250) NOT NULL,  `varcity` varchar(250) NOT NULL,  `varstate` varchar(250) NOT NULL,  `varcountry` varchar(250) NOT NULL,  `varpostalcode` varchar(10) default NULL,  `intshipping` int(11) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblcustmerbasketattributes` (  `intid` int(20) NOT NULL auto_increment,  `intcustomerbasketid` int(20) NOT NULL,  `intproductoptionid` int(20) NOT NULL,  `intproductoptionvalueid` int(20) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

CREATE TABLE `tblcustomeradd` (  `intid` int(11) NOT NULL auto_increment,  `intcustomerid` varchar(100) NOT NULL,  `varcustomerstreetaddress` varchar(100) NOT NULL,  `varcustomercity` varchar(100) NOT NULL,  `varcustomerpostcode` varchar(100) NOT NULL,  `varcustomerstate` varchar(100) NOT NULL,  `varcustomercountry` varchar(100) NOT NULL,  `vardeliverystreetaddress` varchar(100) NOT NULL,  `vardeliverycity` varchar(100) NOT NULL,  `vardeliverypostcode` varchar(100) NOT NULL,  `vardeliverystate` varchar(100) NOT NULL,  `vardeliverycountry` varchar(100) NOT NULL,  `varbillingstreetaddress` varchar(100) NOT NULL,  `varbillingcity` varchar(100) NOT NULL,  `varbillingpostcode` varchar(100) NOT NULL,  `varbillingstate` varchar(100) NOT NULL,  `varbillingcountry` varchar(100) NOT NULL,  `dtfinished` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`intid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `tblcustomerbaskets` (  `intid` int(20) NOT NULL auto_increment,  `varsessionid` varchar(200) NOT NULL,  `varip` varchar(30) NOT NULL,  `intcustomerid` int(20) NOT NULL,  `intproductid` varchar(200) default NULL,  `intproductquantity` int(20) NOT NULL,  `dectotalprice` decimal(10,2) NOT NULL,  `dtdateadded` datetime NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

CREATE TABLE `tblcustomers` (  `intcusid` int(11) NOT NULL auto_increment,  `charcustsex` char(10) NOT NULL,  `varcustfname` varchar(100) NOT NULL,  `varcustlname` varchar(100) NOT NULL,  `dtdob` varchar(200) default NULL,  `varcustemail` varchar(100) NOT NULL,  `varhouseno` varchar(200) NOT NULL,  `varstreetname` varchar(200) NOT NULL,  `varpostalcode` varchar(200) NOT NULL,  `varcity` varchar(200) NOT NULL,  `varstate` varchar(200) NOT NULL,  `varcountry` varchar(200) NOT NULL,  `varcustphone` varchar(100) default '0',  `varcustfax` varchar(100) NOT NULL,  `varcustpassword` varchar(100) NOT NULL,  `intnewsletter` int(11) NOT NULL,  `intstatus` int(11) NOT NULL,  `dtregtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`intcusid`),  UNIQUE KEY `varcustemail` (`varcustemail`),  UNIQUE KEY `varcustemail_2` (`varcustemail`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tbldiscountcode` (  `intid` int(11) NOT NULL auto_increment,  `intcusid` int(11) NOT NULL,  `varcode` varchar(20) NOT NULL,  `dtstart` date NOT NULL,  `dtexpire` date default NULL,  `intstatus` int(11) NOT NULL,  `intamttime` int(20) NOT NULL,  `decdiscount` decimal(10,2) default NULL,  `intdesctype` int(3) NOT NULL,  `decminbuy` decimal(10,2) NOT NULL,  `decmaxbuy` decimal(10,2) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblemails` (  `intid` int(20) NOT NULL auto_increment,  `varsignupsub` varchar(200) NOT NULL,  `txtsignupmess` text NOT NULL,  `varcontactsub` varchar(200) NOT NULL,  `txtcontactmess` text NOT NULL,  `varwelcomesub` varchar(200) NOT NULL,  `txtwelcomemess` text NOT NULL,  `varpasssub` varchar(200) NOT NULL,  `txtpassmess` text NOT NULL,  `varstatussub` varchar(200) NOT NULL,  `txtstatusmess` text NOT NULL,  `varnewssub` varchar(200) NOT NULL,  `txtnewmess` text NOT NULL,  `varcntmess` varchar(200) NOT NULL,  `varsubwish` varchar(200) NOT NULL,  `txtmesswish` text NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `tblfaq` (  `intid` int(11) NOT NULL auto_increment,  `vartitle` varchar(200) NOT NULL,  `varquestion` varchar(200) NOT NULL,  `varanswer` text,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `tblideas` (  `intid` int(11) NOT NULL auto_increment,  `vargiftideatitle` varchar(250) NOT NULL,  `vardesc` varchar(255) NOT NULL,  `varthimg` varchar(250) NOT NULL,  `inttype` int(11) NOT NULL,  `dtideavalid` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `intstatus` int(20) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblimagesettings` (  `intid` int(20) NOT NULL auto_increment,  `intproductthimage` int(20) NOT NULL,  `intmidiumimg` int(11) NOT NULL,  `intproductbigimage` int(20) NOT NULL,  `intcategoryimage` int(20) NOT NULL,  `intsiteforideasorspecialoffers` int(20) NOT NULL,  `intbannerimg` int(20) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `tbllanguages` (  `intlangaugeid` int(20) NOT NULL auto_increment,  `varname` varchar(200) NOT NULL,  `varcode` varchar(200) NOT NULL,  `varcatimage` varchar(255) NOT NULL,  `vardirectory` varchar(200) NOT NULL,  `intsortorder` int(20) NOT NULL,  PRIMARY KEY  (`intlangaugeid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `tblmanufactures` (  `intmanufactureid` int(20) NOT NULL auto_increment,  `varname` varchar(200) NOT NULL,  `varimagepath` varchar(255) NOT NULL,  `txtdesc` text NOT NULL,  `varheading` varchar(200) NOT NULL,  `dtdateadded` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `dtlastmodified` timestamp NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`intmanufactureid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblmystore` (  `intid` int(11) NOT NULL auto_increment,  `varstorename` varchar(250) NOT NULL,  `varstoreownername` varchar(250) NOT NULL,  `varowneremail` varchar(250) NOT NULL,  `varfromemail` varchar(250) NOT NULL,  `varcountry` varchar(250) NOT NULL,  `varzone` varchar(250) NOT NULL,  `varsendordertoemail` varchar(250) NOT NULL,  `varstoreaddsandphone` varchar(255) NOT NULL,  `varwelcometitle` varchar(200) NOT NULL,  `txtwelcomemess` text NOT NULL,  `varpostcode` varchar(12) default NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `tblnewsletters` (  `intid` int(11) NOT NULL auto_increment,  `varsubject` varchar(255) NOT NULL,  `vartext` text NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tbloptionvalues` (  `intid` int(20) NOT NULL auto_increment,  `intlanguageid` int(20) NOT NULL,  `varoptionvaluename` varchar(255) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblorderproductattributes` (  `intid` int(20) NOT NULL auto_increment,  `intorderid` int(20) NOT NULL,  `intorderproductid` int(20) NOT NULL,  `intproductoptionid` int(20) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblorderproducts` (  `intid` int(20) NOT NULL auto_increment,  `intorderid` int(20) NOT NULL,  `intproductid` int(20) NOT NULL,  `varproductmodel` varchar(200) NOT NULL,  `varproductname` varchar(128) NOT NULL,  `decproductprice` decimal(10,2) NOT NULL,  `decfinalprice` decimal(10,2) NOT NULL,  `decimalproducttax` int(4) default NULL,  `intquantity` int(10) default NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblorders` (  `intid` int(20) NOT NULL auto_increment,  `intcustomerid` int(20) NOT NULL,  `varcustomername` varchar(64) NOT NULL,  `varcustomerstreetaddress` varchar(64) NOT NULL,  `varcustomercity` varchar(64) NOT NULL,  `varcustomerpostcode` varchar(64) NOT NULL,  `varcustomerstate` varchar(64) NOT NULL,  `varcustomercountry` varchar(64) NOT NULL,  `varcustomertelephone` varchar(64) NOT NULL,  `varcustomeremailid` varchar(64) NOT NULL,  `vardeliveryname` varchar(64) default '0',  `vardeliverystreetaddress` varchar(64) default '0',  `vardeliverycity` varchar(64) default '0',  `vardeliverypostcode` varchar(64) default '0',  `vardeliverystate` varchar(64) default '0',  `vardeliverycountry` varchar(64) default '0',  `varbillingname` varchar(64) default '0',  `varbillingstreetaddress` varchar(64) default '0',  `varbillingcity` varchar(64) default '0',  `varbillingpostcode` varchar(64) default '0',  `varbillingstate` varchar(64) default '0',  `varbillingcountry` varchar(64) default '0',  `varpaymentmethod` varchar(64) default 'Paypal',  `dtlastmodified` varchar(64) default '0',  `dtdateadded` varchar(64) default '0',  `dtpurchased` varchar(64) default '0',  `intcurrentorderstatus` int(20) default '1',  `dtfinished` datetime default '0000-00-00 00:00:00',  `varcurrency` varchar(64) default '0',  `deccurrencyvalue` decimal(10,2) default '0.00',  `shipmethod` int(11) default NULL,  `totalvalue` decimal(10,2) default NULL,  `discountcode` varchar(50) default NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblorderstatus` (  `intid` int(20) NOT NULL auto_increment,  `varstatus` varchar(200) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE `tblorderstatushistory` (  `intid` int(20) NOT NULL auto_increment,  `intorderid` int(20) NOT NULL,  `intorderstatusid` varchar(200) default NULL,  `dtdateadded` datetime NOT NULL,  `intcustomernotify` int(20) NOT NULL,  `varcomments` varchar(255) NOT NULL,  `varedite` varchar(200) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblpage` (  `intid` int(20) NOT NULL auto_increment,  `vartitle` varchar(200) NOT NULL,  `txtdesc` text NOT NULL,  `varmeta` varchar(200) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE `tblpaypalsettings` (  `intid` int(20) NOT NULL auto_increment,  `varstatus` int(20) NOT NULL,  `varpaypalemail` varchar(200) NOT NULL,  `varcurrency` varchar(100) NOT NULL,  `txtdesc` text NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `tblprodcategory` (  `intcategoryid` int(20) NOT NULL auto_increment,  `varcategoryimage` varchar(255) NOT NULL,  `intparentid` int(20) NOT NULL,  `intsortorder` int(20) NOT NULL,  `dtdateadded` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `dtlastmodified` timestamp NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`intcategoryid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblprodcategorydesc` (  `intid` int(20) NOT NULL auto_increment,  `intcatid` int(20) NOT NULL,  `intlanguageid` int(20) NOT NULL,  `varcategoryname` varchar(200) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblproddesc` (  `intid` varchar(200) NOT NULL default '',  `intlanguageid` int(20) NOT NULL,  `varprodname` varchar(200) NOT NULL,  `txtdesc` text NOT NULL,  `intprodviewed` int(11) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;

CREATE TABLE `tblprodgiftideas` (  `intid` int(11) NOT NULL auto_increment,  `intgiftideaid` int(11) NOT NULL,  `intprodid` varchar(200) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblproductattributes` (  `intattributeid` int(20) NOT NULL auto_increment,  `intproductid` varchar(200) default NULL,  `intoptionid` int(20) NOT NULL,  `intoptionvalueid` int(20) NOT NULL,  `decprice` decimal(10,2) NOT NULL,  `charprefix` char(1) NOT NULL default '+',  PRIMARY KEY  (`intattributeid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblproductoptions` (  `intid` int(11) NOT NULL auto_increment,  `intoptionid` int(20) NOT NULL default '0',  `intlanguageid` int(20) NOT NULL default '1',  `varoptionname` varchar(255) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblproducts` (  `intprodid` varchar(200) NOT NULL,  `intmanufacture` int(20) NOT NULL,  `intcategoryid` int(20) NOT NULL,  `intprodquantity` int(20) NOT NULL,  `intprodmodel` varchar(100) NOT NULL,  `intproddefaultimg` varchar(250) NOT NULL,  `decprice` decimal(10,2) NOT NULL,  `dtaddeddate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `dtlastmodified` timestamp NOT NULL default '0000-00-00 00:00:00',  `dtavailable` timestamp NOT NULL default '0000-00-00 00:00:00',  `decprodweight` decimal(10,2) default '0.00',  `intstatus` int(20) NOT NULL,  `inttaxclassid` int(20) NOT NULL,  `intordered` int(20) NOT NULL,  `varedited` varchar(200) NOT NULL,  PRIMARY KEY  (`intprodid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;

CREATE TABLE `tblproimages` (  `intid` int(11) NOT NULL auto_increment,  `intprodid` varchar(200) default NULL,  `varthpath` varchar(250) NOT NULL,  `varbigpath` varchar(250) NOT NULL,  `intstatus` int(11) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblram` (  `intid` int(11) NOT NULL auto_increment,  `intorderid` varchar(100) NOT NULL,  `varcustemail` varchar(100) NOT NULL,  `intproid` varchar(100) NOT NULL,  `intstatus` varchar(100) NOT NULL,  `ttdate` varchar(100) NOT NULL,  `txtcomments` varchar(100) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `tblratings` (  `intid` int(11) NOT NULL auto_increment,  `intrateto` varchar(200) NOT NULL,  `varratefromemail` varchar(200) NOT NULL,  `varratefromname` varchar(200) NOT NULL,  `intrate` varchar(200) NOT NULL,  `varcomments` varchar(200) NOT NULL,  `varrateip` varchar(200) NOT NULL,  `ttrated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`intid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `tblrelatedproduct` (  `intid` int(20) NOT NULL auto_increment,  `intprodid` varchar(200) NOT NULL,  `intrelatedid` varchar(200) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tblshippingmaster` (  `intid` int(11) NOT NULL auto_increment,  `vartitle` varchar(250) NOT NULL,  `vardesc` varchar(250) NOT NULL,  `intstatus` int(11) NOT NULL,  `decshipcost` decimal(10,2) NOT NULL,  `inttax` int(11) NOT NULL,  `inttaxclass` int(11) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE `tblsupplierorder` (  `intid` int(20) NOT NULL auto_increment,  `intorderid` varchar(200) default NULL,  `varproductid` varchar(200) NOT NULL,  `varproductname` varchar(200) NOT NULL,  `intproprice` int(20) NOT NULL,  `intproqty` int(20) NOT NULL,  `varsupplieremail` varchar(200) NOT NULL,  `varcomment` varchar(200) NOT NULL,  `varpayment` varchar(200) NOT NULL,  `dateadd` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `varstatus` varchar(200) NOT NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `tbltaxrates` (  `intid` int(11) NOT NULL auto_increment,  `vatrate` varchar(10) default NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `tblwishlist` (  `intid` int(20) NOT NULL auto_increment,  `intmemid` int(20) NOT NULL,  `intproductid` varchar(200) default NULL,  PRIMARY KEY  (`intid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;